﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="wfFHJLDataSet" targetNamespace="http://tempuri.org/wfFHJLDataSet.xsd" xmlns:mstns="http://tempuri.org/wfFHJLDataSet.xsd" xmlns="http://tempuri.org/wfFHJLDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="wfFHJLConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="wfFHJLConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.fhjlDAL.Properties.Settings.GlobalReference.Default.wfFHJLConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="供热公司TableAdapter" GeneratorDataComponentClassName="供热公司TableAdapter" Name="供热公司" UserDataComponentName="供热公司TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="wfFHJL.dbo.供热公司" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   ID, 名称, 地址, 备注, Operator, AddTime, IsAvailable
FROM      供热公司
WHERE   (@SQLType = 0) OR
                (@SQLType = 1) AND (ID = @ID) OR
                (@SQLType = 2) AND (名称 = @名称)
ORDER BY AddTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SQLType" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@SQLType" Precision="0" ProviderType="Int" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="名称" ColumnName="名称" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@名称" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="名称" DataSetColumn="名称" />
              <Mapping SourceColumn="地址" DataSetColumn="地址" />
              <Mapping SourceColumn="备注" DataSetColumn="备注" />
              <Mapping SourceColumn="IsAvailable" DataSetColumn="IsAvailable" />
              <Mapping SourceColumn="Operator" DataSetColumn="Operator" />
              <Mapping SourceColumn="AddTime" DataSetColumn="AddTime" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM 供热公司
WHERE   (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO 供热公司
                (名称, 地址, 备注, IsAvailable, Operator, AddTime)
VALUES   (@Name,@Addr,@BZ,@IsAvailable,@Operator,@Time)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Name" ColumnName="名称" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Addr" ColumnName="地址" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@Addr" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="地址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="BZ" ColumnName="备注" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="varchar(200)" DbType="AnsiString" Direction="Input" ParameterName="@BZ" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumn="备注" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsAvailable" ColumnName="IsAvailable" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAvailable" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAvailable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Operator" ColumnName="Operator" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Operator" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Time" ColumnName="AddTime" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE  供热公司
SET         名称 = @Name, 地址 = @Addr, 备注 = @BZ, IsAvailable = @IsAvailable, Operator = @Operator, 
                AddTime = @Time
WHERE   (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Name" ColumnName="名称" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Addr" ColumnName="地址" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@Addr" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="地址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="BZ" ColumnName="备注" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="varchar(200)" DbType="AnsiString" Direction="Input" ParameterName="@BZ" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumn="备注" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsAvailable" ColumnName="IsAvailable" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAvailable" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAvailable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Operator" ColumnName="Operator" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Operator" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Time" ColumnName="AddTime" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.供热公司" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="锅炉房TableAdapter" GeneratorDataComponentClassName="锅炉房TableAdapter" Name="锅炉房" UserDataComponentName="锅炉房TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="wfFHJL.dbo.锅炉房" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   ID, 名称, 地址, 备注, Operator, AddTime, IsAvailable
FROM      锅炉房
WHERE   (@SQLType = 0) AND (供热公司ID = @grgsID) OR
                (@SQLType = 1) AND (ID = @ID) OR
                (@SQLType = 2) AND (供热公司ID = @grgsID) AND (名称 = @名称)
ORDER BY AddTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SQLType" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@SQLType" Precision="0" ProviderType="Int" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="grgsID" ColumnName="供热公司ID" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@grgsID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="供热公司ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="名称" ColumnName="名称" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@名称" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="名称" DataSetColumn="名称" />
              <Mapping SourceColumn="地址" DataSetColumn="地址" />
              <Mapping SourceColumn="备注" DataSetColumn="备注" />
              <Mapping SourceColumn="IsAvailable" DataSetColumn="IsAvailable" />
              <Mapping SourceColumn="Operator" DataSetColumn="Operator" />
              <Mapping SourceColumn="AddTime" DataSetColumn="AddTime" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM 锅炉房
WHERE   (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO 锅炉房
                (名称, 地址, 备注, IsAvailable, Operator, AddTime, 供热公司ID)
VALUES   (@Name,@Addr,@BZ,@IsAvailable,@Operator,@Time,@grgsID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Name" ColumnName="名称" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Addr" ColumnName="地址" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@Addr" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="地址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="BZ" ColumnName="备注" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="varchar(200)" DbType="AnsiString" Direction="Input" ParameterName="@BZ" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumn="备注" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsAvailable" ColumnName="IsAvailable" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAvailable" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAvailable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Operator" ColumnName="Operator" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Operator" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Time" ColumnName="AddTime" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="grgsID" ColumnName="供热公司ID" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@grgsID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="供热公司ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE  锅炉房
SET         名称 = @Name, 地址 = @Addr, 备注 = @BZ, IsAvailable = @IsAvailable, Operator = @Operator, 
                AddTime = @Time
WHERE   (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Name" ColumnName="名称" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Addr" ColumnName="地址" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@Addr" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="地址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="BZ" ColumnName="备注" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="varchar(200)" DbType="AnsiString" Direction="Input" ParameterName="@BZ" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumn="备注" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsAvailable" ColumnName="IsAvailable" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAvailable" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAvailable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Operator" ColumnName="Operator" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Operator" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Time" ColumnName="AddTime" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="换热站TableAdapter" GeneratorDataComponentClassName="换热站TableAdapter" Name="换热站" UserDataComponentName="换热站TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="wfFHJL.dbo.换热站" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, 名称, 地址, 备注, Operator, AddTime, IsAvailable
FROM 换热站
WHERE (@SQLType = 0) AND (锅炉房ID = @锅炉房ID) OR
      (@SQLType = 1) AND (ID = @ID) OR
      (@SQLType = 2) AND (名称 = @名称) AND (锅炉房ID = @锅炉房ID)
ORDER BY AddTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SQLType" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@SQLType" Precision="0" ProviderType="Int" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="锅炉房ID" ColumnName="锅炉房ID" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@锅炉房ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="锅炉房ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="名称" ColumnName="名称" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@名称" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="名称" DataSetColumn="名称" />
              <Mapping SourceColumn="地址" DataSetColumn="地址" />
              <Mapping SourceColumn="备注" DataSetColumn="备注" />
              <Mapping SourceColumn="IsAvailable" DataSetColumn="IsAvailable" />
              <Mapping SourceColumn="Operator" DataSetColumn="Operator" />
              <Mapping SourceColumn="AddTime" DataSetColumn="AddTime" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM 换热站
WHERE   (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO 换热站
                (名称, 地址, 备注, IsAvailable, Operator, AddTime, 锅炉房ID)
VALUES   (@Name,@Addr,@BZ,@IsAvailable,@Operator,@Time,@glfID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Name" ColumnName="名称" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Addr" ColumnName="地址" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@Addr" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="地址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="BZ" ColumnName="备注" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="varchar(200)" DbType="AnsiString" Direction="Input" ParameterName="@BZ" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumn="备注" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsAvailable" ColumnName="IsAvailable" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAvailable" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAvailable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Operator" ColumnName="Operator" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Operator" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Time" ColumnName="AddTime" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="glfID" ColumnName="锅炉房ID" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@glfID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="锅炉房ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE  换热站
SET         名称 = @Name, 地址 = @Addr, 备注 = @BZ, IsAvailable = @IsAvailable, Operator = @Operator, 
                AddTime = @Time
WHERE   (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Name" ColumnName="名称" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Addr" ColumnName="地址" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@Addr" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="地址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="BZ" ColumnName="备注" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="varchar(200)" DbType="AnsiString" Direction="Input" ParameterName="@BZ" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumn="备注" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsAvailable" ColumnName="IsAvailable" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAvailable" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAvailable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Operator" ColumnName="Operator" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Operator" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Time" ColumnName="AddTime" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="glfNameTableAdapter" GeneratorDataComponentClassName="glfNameTableAdapter" Name="glfName" UserDataComponentName="glfNameTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetName" GetMethodModifier="Public" GetMethodName="GetName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetName" UserSourceName="GetName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT 供热公司.名称 AS 供热公司名称, 锅炉房.名称 AS 锅炉房名称
FROM 锅炉房 INNER JOIN
      供热公司 ON 锅炉房.供热公司ID = 供热公司.ID
WHERE (锅炉房.ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.锅炉房" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="供热公司名称" DataSetColumn="供热公司名称" />
              <Mapping SourceColumn="锅炉房名称" DataSetColumn="锅炉房名称" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="小区TableAdapter" GeneratorDataComponentClassName="小区TableAdapter" Name="小区" UserDataComponentName="小区TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="wfFHJL.dbo.小区" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   ID, 名称, 地址, 备注, Operator, AddTime, IsAvailable
FROM      小区
WHERE   (@SQLType = 0) AND (换热站ID = @grgsID) OR
                (@SQLType = 1) AND (ID = @ID) OR
                (@SQLType = 2) AND (换热站ID = @grgsID) AND (名称 = @名称)
ORDER BY AddTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SQLType" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@SQLType" Precision="0" ProviderType="Int" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="grgsID" ColumnName="换热站ID" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@grgsID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="换热站ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="名称" ColumnName="名称" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@名称" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="名称" DataSetColumn="名称" />
              <Mapping SourceColumn="地址" DataSetColumn="地址" />
              <Mapping SourceColumn="备注" DataSetColumn="备注" />
              <Mapping SourceColumn="Operator" DataSetColumn="Operator" />
              <Mapping SourceColumn="AddTime" DataSetColumn="AddTime" />
              <Mapping SourceColumn="IsAvailable" DataSetColumn="IsAvailable" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM 小区
WHERE   (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO 小区
                (名称, 地址, 备注, IsAvailable, Operator, AddTime, 换热站ID)
VALUES   (@Name,@Addr,@BZ,@IsAvailable,@Operator,@Time,@hrzID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Name" ColumnName="名称" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Addr" ColumnName="地址" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@Addr" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="地址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="BZ" ColumnName="备注" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="varchar(200)" DbType="AnsiString" Direction="Input" ParameterName="@BZ" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumn="备注" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsAvailable" ColumnName="IsAvailable" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAvailable" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAvailable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Operator" ColumnName="Operator" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Operator" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Time" ColumnName="AddTime" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="hrzID" ColumnName="换热站ID" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@hrzID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="换热站ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE  小区
SET         名称 = @Name, 地址 = @Addr, 备注 = @BZ, IsAvailable = @IsAvailable, Operator = @Operator, 
                AddTime = @Time
WHERE   (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Name" ColumnName="名称" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="名称" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Addr" ColumnName="地址" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="varchar(150)" DbType="AnsiString" Direction="Input" ParameterName="@Addr" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumn="地址" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="BZ" ColumnName="备注" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="varchar(200)" DbType="AnsiString" Direction="Input" ParameterName="@BZ" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumn="备注" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsAvailable" ColumnName="IsAvailable" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAvailable" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAvailable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Operator" ColumnName="Operator" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Operator" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Time" ColumnName="AddTime" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="AddTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.小区" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="hrzNameTableAdapter" GeneratorDataComponentClassName="hrzNameTableAdapter" Name="hrzName" UserDataComponentName="hrzNameTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="wfFHJLConnectionString (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetName" GetMethodModifier="Public" GetMethodName="GetName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetName" UserSourceName="GetName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT 供热公司.名称 AS 供热公司名称, 锅炉房.名称 AS 锅炉房名称, 
      换热站.名称 AS 换热站名称
FROM 锅炉房 INNER JOIN
      供热公司 ON 锅炉房.供热公司ID = 供热公司.ID INNER JOIN
      换热站 ON 锅炉房.ID = 换热站.锅炉房ID
WHERE (换热站.ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="wfFHJL.dbo.换热站" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="供热公司名称" DataSetColumn="供热公司名称" />
              <Mapping SourceColumn="锅炉房名称" DataSetColumn="锅炉房名称" />
              <Mapping SourceColumn="换热站名称" DataSetColumn="换热站名称" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="wfFHJLDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="wfFHJLDataSet" msprop:Generator_DataSetName="wfFHJLDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="供热公司" msprop:Generator_UserTableName="供热公司" msprop:Generator_RowDeletedName="供热公司RowDeleted" msprop:Generator_RowChangedName="供热公司RowChanged" msprop:Generator_RowClassName="供热公司Row" msprop:Generator_RowChangingName="供热公司RowChanging" msprop:Generator_RowEvArgName="供热公司RowChangeEvent" msprop:Generator_RowEvHandlerName="供热公司RowChangeEventHandler" msprop:Generator_TableClassName="供热公司DataTable" msprop:Generator_TableVarName="table供热公司" msprop:Generator_RowDeletingName="供热公司RowDeleting" msprop:Generator_TablePropName="供热公司">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
              <xs:element name="名称" msprop:Generator_UserColumnName="名称" msprop:Generator_ColumnVarNameInTable="column名称" msprop:Generator_ColumnPropNameInRow="名称" msprop:Generator_ColumnPropNameInTable="名称Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="地址" msprop:Generator_UserColumnName="地址" msprop:Generator_ColumnVarNameInTable="column地址" msprop:Generator_ColumnPropNameInRow="地址" msprop:Generator_ColumnPropNameInTable="地址Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="备注" msprop:Generator_UserColumnName="备注" msprop:Generator_ColumnVarNameInTable="column备注" msprop:Generator_ColumnPropNameInRow="备注" msprop:Generator_ColumnPropNameInTable="备注Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsAvailable" msprop:Generator_UserColumnName="IsAvailable" msprop:Generator_ColumnVarNameInTable="columnIsAvailable" msprop:Generator_ColumnPropNameInRow="IsAvailable" msprop:Generator_ColumnPropNameInTable="IsAvailableColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Operator" msprop:Generator_UserColumnName="Operator" msprop:Generator_ColumnVarNameInTable="columnOperator" msprop:Generator_ColumnPropNameInRow="Operator" msprop:Generator_ColumnPropNameInTable="OperatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddTime" msprop:Generator_UserColumnName="AddTime" msprop:Generator_ColumnVarNameInTable="columnAddTime" msprop:Generator_ColumnPropNameInRow="AddTime" msprop:Generator_ColumnPropNameInTable="AddTimeColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="锅炉房" msprop:Generator_UserTableName="锅炉房" msprop:Generator_RowDeletedName="锅炉房RowDeleted" msprop:Generator_RowChangedName="锅炉房RowChanged" msprop:Generator_RowClassName="锅炉房Row" msprop:Generator_RowChangingName="锅炉房RowChanging" msprop:Generator_RowEvArgName="锅炉房RowChangeEvent" msprop:Generator_RowEvHandlerName="锅炉房RowChangeEventHandler" msprop:Generator_TableClassName="锅炉房DataTable" msprop:Generator_TableVarName="table锅炉房" msprop:Generator_RowDeletingName="锅炉房RowDeleting" msprop:Generator_TablePropName="锅炉房">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
              <xs:element name="名称" msprop:Generator_UserColumnName="名称" msprop:Generator_ColumnVarNameInTable="column名称" msprop:Generator_ColumnPropNameInRow="名称" msprop:Generator_ColumnPropNameInTable="名称Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="地址" msprop:Generator_UserColumnName="地址" msprop:Generator_ColumnVarNameInTable="column地址" msprop:Generator_ColumnPropNameInRow="地址" msprop:Generator_ColumnPropNameInTable="地址Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="备注" msprop:Generator_UserColumnName="备注" msprop:Generator_ColumnVarNameInTable="column备注" msprop:Generator_ColumnPropNameInRow="备注" msprop:Generator_ColumnPropNameInTable="备注Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsAvailable" msprop:Generator_UserColumnName="IsAvailable" msprop:Generator_ColumnVarNameInTable="columnIsAvailable" msprop:Generator_ColumnPropNameInRow="IsAvailable" msprop:Generator_ColumnPropNameInTable="IsAvailableColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Operator" msprop:Generator_UserColumnName="Operator" msprop:Generator_ColumnVarNameInTable="columnOperator" msprop:Generator_ColumnPropNameInRow="Operator" msprop:Generator_ColumnPropNameInTable="OperatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddTime" msprop:Generator_UserColumnName="AddTime" msprop:Generator_ColumnVarNameInTable="columnAddTime" msprop:Generator_ColumnPropNameInRow="AddTime" msprop:Generator_ColumnPropNameInTable="AddTimeColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="换热站" msprop:Generator_UserTableName="换热站" msprop:Generator_RowDeletedName="换热站RowDeleted" msprop:Generator_TableClassName="换热站DataTable" msprop:Generator_RowChangedName="换热站RowChanged" msprop:Generator_RowClassName="换热站Row" msprop:Generator_RowChangingName="换热站RowChanging" msprop:Generator_RowEvArgName="换热站RowChangeEvent" msprop:Generator_RowEvHandlerName="换热站RowChangeEventHandler" msprop:Generator_TablePropName="换热站" msprop:Generator_TableVarName="table换热站" msprop:Generator_RowDeletingName="换热站RowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
              <xs:element name="名称" msprop:Generator_UserColumnName="名称" msprop:Generator_ColumnPropNameInRow="名称" msprop:Generator_ColumnVarNameInTable="column名称" msprop:Generator_ColumnPropNameInTable="名称Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="地址" msprop:Generator_UserColumnName="地址" msprop:Generator_ColumnPropNameInRow="地址" msprop:Generator_ColumnVarNameInTable="column地址" msprop:Generator_ColumnPropNameInTable="地址Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="备注" msprop:Generator_UserColumnName="备注" msprop:Generator_ColumnPropNameInRow="备注" msprop:Generator_ColumnVarNameInTable="column备注" msprop:Generator_ColumnPropNameInTable="备注Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsAvailable" msprop:Generator_UserColumnName="IsAvailable" msprop:Generator_ColumnPropNameInRow="IsAvailable" msprop:Generator_ColumnVarNameInTable="columnIsAvailable" msprop:Generator_ColumnPropNameInTable="IsAvailableColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Operator" msprop:Generator_UserColumnName="Operator" msprop:Generator_ColumnPropNameInRow="Operator" msprop:Generator_ColumnVarNameInTable="columnOperator" msprop:Generator_ColumnPropNameInTable="OperatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddTime" msprop:Generator_UserColumnName="AddTime" msprop:Generator_ColumnPropNameInRow="AddTime" msprop:Generator_ColumnVarNameInTable="columnAddTime" msprop:Generator_ColumnPropNameInTable="AddTimeColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="glfName" msprop:Generator_UserTableName="glfName" msprop:Generator_RowDeletedName="glfNameRowDeleted" msprop:Generator_TableClassName="glfNameDataTable" msprop:Generator_RowChangedName="glfNameRowChanged" msprop:Generator_RowClassName="glfNameRow" msprop:Generator_RowChangingName="glfNameRowChanging" msprop:Generator_RowEvArgName="glfNameRowChangeEvent" msprop:Generator_RowEvHandlerName="glfNameRowChangeEventHandler" msprop:Generator_TablePropName="glfName" msprop:Generator_TableVarName="tableglfName" msprop:Generator_RowDeletingName="glfNameRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="供热公司名称" msprop:Generator_UserColumnName="供热公司名称" msprop:Generator_ColumnPropNameInRow="供热公司名称" msprop:Generator_ColumnVarNameInTable="column供热公司名称" msprop:Generator_ColumnPropNameInTable="供热公司名称Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="锅炉房名称" msprop:Generator_UserColumnName="锅炉房名称" msprop:Generator_ColumnPropNameInRow="锅炉房名称" msprop:Generator_ColumnVarNameInTable="column锅炉房名称" msprop:Generator_ColumnPropNameInTable="锅炉房名称Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="小区" msprop:Generator_UserTableName="小区" msprop:Generator_RowDeletedName="小区RowDeleted" msprop:Generator_TableClassName="小区DataTable" msprop:Generator_RowChangedName="小区RowChanged" msprop:Generator_RowClassName="小区Row" msprop:Generator_RowChangingName="小区RowChanging" msprop:Generator_RowEvArgName="小区RowChangeEvent" msprop:Generator_RowEvHandlerName="小区RowChangeEventHandler" msprop:Generator_TablePropName="小区" msprop:Generator_TableVarName="table小区" msprop:Generator_RowDeletingName="小区RowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
              <xs:element name="名称" msprop:Generator_UserColumnName="名称" msprop:Generator_ColumnPropNameInRow="名称" msprop:Generator_ColumnVarNameInTable="column名称" msprop:Generator_ColumnPropNameInTable="名称Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="地址" msprop:Generator_UserColumnName="地址" msprop:Generator_ColumnPropNameInRow="地址" msprop:Generator_ColumnVarNameInTable="column地址" msprop:Generator_ColumnPropNameInTable="地址Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="备注" msprop:Generator_UserColumnName="备注" msprop:Generator_ColumnPropNameInRow="备注" msprop:Generator_ColumnVarNameInTable="column备注" msprop:Generator_ColumnPropNameInTable="备注Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Operator" msprop:Generator_UserColumnName="Operator" msprop:Generator_ColumnPropNameInRow="Operator" msprop:Generator_ColumnVarNameInTable="columnOperator" msprop:Generator_ColumnPropNameInTable="OperatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddTime" msprop:Generator_UserColumnName="AddTime" msprop:Generator_ColumnPropNameInRow="AddTime" msprop:Generator_ColumnVarNameInTable="columnAddTime" msprop:Generator_ColumnPropNameInTable="AddTimeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IsAvailable" msprop:Generator_UserColumnName="IsAvailable" msprop:Generator_ColumnPropNameInRow="IsAvailable" msprop:Generator_ColumnVarNameInTable="columnIsAvailable" msprop:Generator_ColumnPropNameInTable="IsAvailableColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="hrzName" msprop:Generator_UserTableName="hrzName" msprop:Generator_RowDeletedName="hrzNameRowDeleted" msprop:Generator_TableClassName="hrzNameDataTable" msprop:Generator_RowChangedName="hrzNameRowChanged" msprop:Generator_RowClassName="hrzNameRow" msprop:Generator_RowChangingName="hrzNameRowChanging" msprop:Generator_RowEvArgName="hrzNameRowChangeEvent" msprop:Generator_RowEvHandlerName="hrzNameRowChangeEventHandler" msprop:Generator_TablePropName="hrzName" msprop:Generator_TableVarName="tablehrzName" msprop:Generator_RowDeletingName="hrzNameRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="供热公司名称" msprop:Generator_UserColumnName="供热公司名称" msprop:Generator_ColumnPropNameInRow="供热公司名称" msprop:Generator_ColumnVarNameInTable="column供热公司名称" msprop:Generator_ColumnPropNameInTable="供热公司名称Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="锅炉房名称" msprop:Generator_UserColumnName="锅炉房名称" msprop:Generator_ColumnPropNameInRow="锅炉房名称" msprop:Generator_ColumnVarNameInTable="column锅炉房名称" msprop:Generator_ColumnPropNameInTable="锅炉房名称Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="换热站名称" msprop:Generator_UserColumnName="换热站名称" msprop:Generator_ColumnPropNameInRow="换热站名称" msprop:Generator_ColumnVarNameInTable="column换热站名称" msprop:Generator_ColumnPropNameInTable="换热站名称Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:供热公司" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="锅炉房_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:锅炉房" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="换热站_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:换热站" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="小区_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:小区" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>